<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<?php
require_once 'model/db2.php';
?>

<h1> Lê Bảo Bảo</h1>
<?php
$query = "SELECT * FROM companies";
$companies = getPage($query);
$query = "SELECT * FROM apps";
$apps = getPage($query);
?>
<form method="POST">
    Min :<input type="text" name="min_fans"><br>
    Max :<input type="text" name="max_fans"><br>
    Keyword :<input type="text" name="keyword"><br>
    Company :<select name="id_company">
        <option value="0">------------</option>
        <?php foreach ($companies as $company): ?>
            <option value="<?php echo $company['id'] ?>"><?php echo $company['name'] ?></option>
        <?php endforeach; ?>
    </select><br>
    Application :<select name="id_apps">
        <option value="0">---------------------------------------------------------</option>
        <?php foreach ($apps as $app): ?>
        <option value="<?php echo $app['id'] ?>"><?php echo $app['name'] ?></option>
        <?php endforeach; ?>
    </select><br>
    <input type="submit" name="submit">
</form>

<?php if (isset($_POST['submit'])): // isset kiem tra co ton tai kg ?>
    <?php
    $min_fans = $_POST['min_fans'];
    $max_fans = $_POST['max_fans']; 
    $keyword = $_POST['keyword']; 
    $company = $_POST["id_company"];
    $apps = $_POST["id_apps"];
    if (!empty($company)) //empty ktra rong kg.
        $company = "companies.id=$company AND";
    else
        $company = "";
    if (!empty($apps))
        $apps = "companies.id=$apps AND";
    else
        $apps = "";
    if (empty($max_fans) && !empty($min_fans)) {
        $query = "SELECT * FROM pages
            INNER JOIN apps_pages ON pages.id=apps_pages.id_page
            INNER JOIN apps ON apps.id=apps_pages.id_app
            INNER JOIN companies ON companies.id=apps.id_company
            where $company
                  $apps 
                  pages.likes>= $min_fans and
                  pages.description LIKE '% $keyword %'
                  LIMIT 0,10";
    } else if (!empty($max_fans) && empty($min_fans)) {
        $query = "SELECT * FROM pages
            INNER JOIN apps_pages ON pages.id=apps_pages.id_page
            INNER JOIN apps ON apps.id=apps_pages.id_app
            INNER JOIN companies ON companies.id=apps.id_company
            where $company
                  $apps
                  pages.likes<= $max_fans and
                  pages.description LIKE '% $keyword %'
                  LIMIT 0,10";
    } else if (empty($max_fans) && empty($min_fans)) {
        $query = "SELECT * FROM pages
            INNER JOIN apps_pages ON pages.id=apps_pages.id_page
            INNER JOIN apps ON apps.id=apps_pages.id_app
            INNER JOIN companies ON companies.id=apps.id_company
            where $company
                  $apps
                  pages.description LIKE '% $keyword %'
                  LIMIT 0,10";
    } else {
        $query = "SELECT * FROM pages
            INNER JOIN apps_pages ON pages.id=apps_pages.id_page
            INNER JOIN apps ON apps.id=apps_pages.id_app
            INNER JOIN companies ON companies.id=apps.id_company
            where $company
                  $apps
                  pages.likes>= $min_fans and
                  pages.likes<= $max_fans and
                  pages.description LIKE '% $keyword %'
                  LIMIT 0,10";
    }
    $pages = getPage($query);
    var_dump($query);
    ?>

    <?php if (!empty($pages)): ?>
    <table border ="1">
        <tr>
            <td class="pid">STT </td>
            <td class="picture">picture </td>
            <td class="name">Name</td>
            <td class="likes">Likes</td>
            <td class="talking">Talking</td>
            <td class="category">Category</td>
            <td class="link">Link </td>
            <td class="website">Website</td>
            <td class="country">Country </td>
            <td class="description">Profile </td>
        </tr>
    <?php foreach ($pages as $page): ?>

            <tr>
                <td><?php echo $page["pid"] ?></td>
                <td><img src = '<?php echo $page["picture"] ?>'></td>
                <td><?php echo $page["name"] ?></td>
                <td><?php echo $page["likes"] ?></td>
                <td><?php echo $page["talking_about_count"] ?></td>
                <td><?php echo $page["category"] ?></td>
                <td><?php echo $page["link"] ?></td>
                <td><?php echo $page["website"] ?></td>
                <td><?php echo $page["country"] ?></td>
                <td><?php echo substr($page["description"] ,0,100) ?></td>
            </tr>

    <?php endforeach; ?>
    </table>
<?php endif; ?>
  <?php endif; ?>
